{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Flexibility Analysis","CAFE Contributes","Compliance Overview"],"not_rendered":{"charts":10,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Flexibility Analysis","index":0,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SUMMARY STATISTICS I"]
[null,null,"Shortfall \n(Credits)","Shortfall\n($)","Civil Penalty (Credits)","Civil Penalty\n($)","%age SF Resolved by CP","%age SF Resolved by Credits"]
[null,2011,19694045,{"$f":"C4*5.5","v":108317247.5},7275140,{"$f":"E4*5.5","v":40013270},{"$f":"F4/D4","v":0.36940811296003434},{"$f":"1-G4","v":0.6305918870399656}]
[null,2012,41033802,225685911,2720433,14962381.5,6.6297366254289572E-2,0.93370263374571039]
[null,2013,35836987,197103428.5,3876210,21319155,0.10816227379829671,0.89183772620170332]
[null,2014,46578649,256182569.5,416325,2289787.5,8.9381081018472652E-3,0.99106189189815275]
[null,2015,83297682,458137251,0,0,0,1]
[null,2016,183720769,1010464229.5,14048855,77268702.5,7.6468518374207331E-2,0.92353148162579268]
[null,2017,166715863,916937246.5,14432117,79376643.5,8.6567149282009231E-2,{"$f":"1-G10","v":0.91343285071799074}]
[null,2018,"pending","pending","pending","pending","pending","pending"]
[null,2019,"pending","pending","pending","pending","pending","pending"]
[null,2020,"pending","pending","pending","pending","pending","pending"]
[null,"TOTAL",{"$f":"SUM(C4:C11)","v":576877797},{"$f":"SUM(D4:D11)","v":3172827883.5},{"$f":"SUM(E4:E11)","v":42769080},{"$f":"E14*5.5","v":235229940},{"$f":"F14/D14","v":7.4138890805672666E-2},{"$f":"1-G14","v":0.92586110919432729}]
[null,"SUMMARY STATISTICS II"]
[null,"Model Year","Carry Forward","Carry Back","Transfer","Trade","Civil Penalty","Remaining"]
[null,2011,3151689,0,0,9195320,7275140,71896]
[null,2012,27672796,583428,0,10057145,2720433,0]
[null,2013,21498068,0,0,10462709,3876210,0]
[null,2014,18144480,0,2594205,24860705,416325,562934]
[null,2015,39157449,0,1397091,41917486,0,825656]
[null,2016,36754491,0,68212135,64705291,14048855,0]
[null,2017,32296705,0,37780657,75468335,14432117,6738049]
[null,2018,"pending","pending","pending","pending","pending","pending"]
[null,2019,"pending","pending","pending","pending","pending","pending"]
[null,2020,"pending","pending","pending","pending","pending","pending"]
[null,"TOTAL",178675678,583428,109984088,236666991,42769080,8198535]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"From: ","CAFE Credit Shortfall Analysis_v37.xlsm"]
[null,null,"\\\\NHTSA-NRDDATA.ad.dot.gov\\nvspubdocs\\NVS\\Enforcement\\OVSC\\CAFE\\Credit Tracking Part 536\\Analysis\\Credit Shortfall Analysis\\Shortfall Analysis"]

{"sheet":"CAFE Contributes","index":1,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,4],[23,0,23,4],[34,0,34,4],[12,0,12,4]]}
[null,"FE Standard","Base CAFE","CAFE w. AMFA Contribution","Final CAFE w ACOC&AMFA"]
["DP"]
[2011,30,32,32.700000000000003,32.700000000000003]
[2012,32.700000000000003,34,34.799999999999997,34.799999999999997]
[2013,33.200000000000003,35.299999999999997,36.1,36.1]
[2014,34,35.5,36.299999999999997,36.299999999999997]
[2015,35.200000000000003,36.6,37.200000000000003,37.200000000000003]
[2016,36.5,36.799999999999997,37.299999999999997,37.299999999999997]
[2017,38.5,38,38.299999999999997,39.200000000000003]
[2018,39.6,39.9,40.200000000000003,41.7]
[2019,41.2,39.299999999999997,39.4,40.799999999999997]
[2020,42.4,41.6,41.6,43.6]
["IP"]
[2011,30.4,33.5,33.700000000000003,33.700000000000003]
[2012,33.4,35.9,36,36]
[2013,33.9,36.6,36.799999999999997,36.799999999999997]
[2014,34.6,36.6,36.9,36.9]
[2015,35.799999999999997,37.1,37.299999999999997,37.299999999999997]
[2016,37.4,38,38.1,38.1]
[2017,39.6,38.6,38.6,39.700000000000003]
[2018,40.6,38.5,38.5,39.6]
[2019,42.2,39,39,40.1]
[2020,44,39.299999999999997,39.299999999999997,40.700000000000003]
["LT"]
[2011,24.3,23.9,24.7,24.7]
[2012,25.3,24.1,25,25]
[2013,25.9,24.8,25.7,25.7]
[2014,26.3,25.5,26.5,26.5]
[2015,27.6,26.5,27.3,27.3]
[2016,28.8,26.8,27.4,27.4]
[2017,29.4,27.4,27.8,28.6]
[2018,30,27.7,28,29.4]
[2019,30.4,27.9,28.1,29.5]
[2020,31,28.6,28.6,30.1]
["TOTAL"]
[2011,27.4,28.2,29,29]
[2012,29.8,30,30.8,30.8]
[2013,30.3,30.9,31.6,31.6]
[2014,30.5,30.8,31.7,31.7]
[2015,31.6,31.6,32.200000000000003,32.200000000000003]
[2016,32.799999999999997,31.7,32.299999999999997,32.299999999999997]
[2017,33.799999999999997,32.299999999999997,32.6,33.4]
[2018,34.1,32.200000000000003,32.5,33.9]
[2019,34.5,32,32.1,33.5]
[2020,35.4,32.799999999999997,32.799999999999997,34.299999999999997]

{"sheet":"Compliance Overview","index":2,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Year","Total FE Std.","Total FE Performance","DP Std.","DP Performance","IP Std.","IP Performance","LT Std.","LT Performance"]
[2011,27.4,29,30,32.700000000000003,30.4,33.700000000000003,24.3,24.7]
[2012,29.8,30.8,32.700000000000003,34.799999999999997,33.4,36,25.3,25]
[2013,30.3,31.6,33.200000000000003,36.1,33.9,36.799999999999997,25.9,25.7]
[2014,30.5,31.7,34,36.299999999999997,34.6,36.9,26.3,26.5]
[2015,31.6,32.200000000000003,35.200000000000003,37.200000000000003,35.799999999999997,37.299999999999997,27.6,27.3]
[2016,32.799999999999997,32.299999999999997,36.5,37.299999999999997,37.4,38.1,28.8,27.4]
[2017,33.799999999999997,33.4,38.5,39.200000000000003,39.6,39.700000000000003,29.4,28.6]
[2018,34.1,33.9,39.6,41.7,40.6,39.6,30,29.4]
[2019,34.5,33.5,41.2,40.799999999999997,42.2,40.1,30.4,29.5]
[2020,35.4,34.299999999999997,42.4,43.6,44,40.700000000000003,31,30.1]